{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 项目人：胡兆杰    \n",
    "## 时间：2020/10\n",
    "## 数据源：https://www.liepin.com/zhaopin/\n",
    "# 目标：\n",
    "#### 抓取广州对于'用户研究','UI设计','产品经理','新媒体运营','前端开发'的就业机会情况，为本科大学生提供关于影视企业更多就业信息，为毕业生就业提供参考。"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 数据来源于猎聘网"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "参考xpath语法:https://www.w3cschool.cn/xpath/xpath-syntax.html\n",
    "\n",
    "pandas基本模块：https://www.cnblogs.com/pfeiliu/p/12903211.html\n",
    "\n",
    "爬虫工具requests-html：https://www.cnblogs.com/fnng/p/8948015.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 基本模块\n",
    "import pandas as pd\n",
    "from requests_html import HTMLSession\n",
    "from urllib.parse import urlparse, parse_qs"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 先爬取猎聘网所有行业类型的参数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'互联网/电商': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_01&jobKind=&industries=040&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '游戏产业': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_01&jobKind=&industries=420&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '计算机软件': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_01&jobKind=&industries=010&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " 'IT服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_01&jobKind=&industries=030&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '电子/芯片/半导体': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_02&jobKind=&industries=050&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '通信业': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_02&jobKind=&industries=060&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '计算机/网络设备': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_02&jobKind=&industries=020&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '房地产/建筑': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_03&jobKind=&industries=080&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '规划/设计/装潢': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_03&jobKind=&industries=100&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '房地产服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_03&jobKind=&industries=090&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '银行': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=130&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '保险': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=140&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '基金/证券/投资': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=150&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '会计/审计': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=430&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '信托/担保/拍卖': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_04&jobKind=&industries=500&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '快消品': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=190&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '批发零售': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=240&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '服装纺织': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=200&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '家具/家电': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=210&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '办公设备': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=220&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '奢侈品/收藏品': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=460&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '珠宝/玩具/工艺品': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_05&jobKind=&industries=470&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '汽车/摩托车': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=350&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '机械/机电/重工': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=360&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '印刷/包装/造纸': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=180&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '原材料加工': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=370&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '仪器/电气/自动化': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_06&jobKind=&industries=340&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '制药/生物工程': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_10&jobKind=&industries=270&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '医疗/保健/美容': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_10&jobKind=&industries=280&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '医疗器械': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_10&jobKind=&industries=290&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '能源/水利': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=330&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '石油/化工': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=310&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '采掘/冶炼/矿产': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=320&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '环保': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=300&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '新能源': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_11&jobKind=&industries=490&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '专业服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=120&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '中介服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=110&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '外包服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=440&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '检测/认证': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=450&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '餐饮/酒旅/服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=230&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '文体娱乐': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=260&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '租赁服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_07&jobKind=&industries=510&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '广告/市场/会展': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_08&jobKind=&industries=070&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '影视文化': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_08&jobKind=&industries=170&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '教育培训': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_08&jobKind=&industries=380&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '交通/物流/运输': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_09&jobKind=&industries=250&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '贸易/进出口': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_09&jobKind=&industries=160&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '航空/航天': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_09&jobKind=&industries=480&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '政务/公共服务': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_12&jobKind=&industries=390&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '农林牧渔': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_12&jobKind=&industries=410&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c',\n",
       " '其他行业': '/zhaopin/?flushckid=1&compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=&compIds=&subIndustry=&industryType=industry_12&jobKind=&industries=400&compscale=&key=PRD&siTag=5pAulR6ffRIsqTOD3tZ_8w%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=575d33e9cf33c5a1bf3cb9a22eb5c23c&d_curPage=0&d_pageSize=40&d_headId=575d33e9cf33c5a1bf3cb9a22eb5c23c'}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url = \"https://www.liepin.com/zhaopin/?key=PRD\"\n",
    "session = HTMLSession()\n",
    "r = session.get( url )\n",
    "\n",
    "行业数据链结 = r.html.xpath('//ul[@class=\"clearfix\"]/li/div/a')\n",
    "行业数据链结\n",
    "\n",
    "# 爬取行业数据链接的文字和链接\n",
    "行业数据链结 = { x.xpath(\"a/text()\")[0]:x.xpath(\"a/@href\")[0] for x in 行业数据链结}\n",
    "行业数据链结"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 分析行业参数的关键参数\n",
    "\n",
    "####  urlparsee返回的6个部分，分别是：scheme(机制)丶netloc(网络位置)丶path(路径)丶params(路径段参数)丶query(查询)丶fragment(片段)。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 51 entries, 0 to 50\n",
      "Data columns (total 6 columns):\n",
      " #   Column    Non-Null Count  Dtype \n",
      "---  ------    --------------  ----- \n",
      " 0   scheme    51 non-null     object\n",
      " 1   netloc    51 non-null     object\n",
      " 2   path      51 non-null     object\n",
      " 3   params    51 non-null     object\n",
      " 4   query     51 non-null     object\n",
      " 5   fragment  51 non-null     object\n",
      "dtypes: object(6)\n",
      "memory usage: 2.5+ KB\n",
      "scheme       1\n",
      "netloc       1\n",
      "path         1\n",
      "params       1\n",
      "query       51\n",
      "fragment     1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>scheme</th>\n",
       "      <th>netloc</th>\n",
       "      <th>path</th>\n",
       "      <th>params</th>\n",
       "      <th>query</th>\n",
       "      <th>fragment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>flushckid=1&amp;compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=4...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  scheme netloc       path params  \\\n",
       "0                /zhaopin/          \n",
       "\n",
       "                                               query fragment  \n",
       "0  flushckid=1&compkind=&dqs=&pubTime=&pageSize=4...           "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame([ urlparse(x) for x in 行业数据链结.values()])\n",
    "df.info()\n",
    "print(df.nunique())\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 针对query 再解析，使用parse_qs返回query(查询)多个部分\n",
    "#### 找到关键参数—— industryType、industries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "flushckid        1\n",
      "pageSize         1\n",
      "industryType    12\n",
      "industries      51\n",
      "key              1\n",
      "siTag            1\n",
      "d_sfrom          1\n",
      "d_ckId           1\n",
      "d_curPage        1\n",
      "d_pageSize       1\n",
      "d_headId         1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flushckid</th>\n",
       "      <th>pageSize</th>\n",
       "      <th>industryType</th>\n",
       "      <th>industries</th>\n",
       "      <th>key</th>\n",
       "      <th>siTag</th>\n",
       "      <th>d_sfrom</th>\n",
       "      <th>d_ckId</th>\n",
       "      <th>d_curPage</th>\n",
       "      <th>d_pageSize</th>\n",
       "      <th>d_headId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>040</td>\n",
       "      <td>PRD</td>\n",
       "      <td>5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>420</td>\n",
       "      <td>PRD</td>\n",
       "      <td>5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>010</td>\n",
       "      <td>PRD</td>\n",
       "      <td>5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>030</td>\n",
       "      <td>PRD</td>\n",
       "      <td>5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>industry_02</td>\n",
       "      <td>050</td>\n",
       "      <td>PRD</td>\n",
       "      <td>5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>575d33e9cf33c5a1bf3cb9a22eb5c23c</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  flushckid pageSize industryType industries  key  \\\n",
       "0         1       40  industry_01        040  PRD   \n",
       "1         1       40  industry_01        420  PRD   \n",
       "2         1       40  industry_01        010  PRD   \n",
       "3         1       40  industry_01        030  PRD   \n",
       "4         1       40  industry_02        050  PRD   \n",
       "\n",
       "                                           siTag         d_sfrom  \\\n",
       "0  5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "1  5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "2  5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "3  5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "4  5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw  search_unknown   \n",
       "\n",
       "                             d_ckId d_curPage d_pageSize  \\\n",
       "0  575d33e9cf33c5a1bf3cb9a22eb5c23c         0         40   \n",
       "1  575d33e9cf33c5a1bf3cb9a22eb5c23c         0         40   \n",
       "2  575d33e9cf33c5a1bf3cb9a22eb5c23c         0         40   \n",
       "3  575d33e9cf33c5a1bf3cb9a22eb5c23c         0         40   \n",
       "4  575d33e9cf33c5a1bf3cb9a22eb5c23c         0         40   \n",
       "\n",
       "                           d_headId  \n",
       "0  575d33e9cf33c5a1bf3cb9a22eb5c23c  \n",
       "1  575d33e9cf33c5a1bf3cb9a22eb5c23c  \n",
       "2  575d33e9cf33c5a1bf3cb9a22eb5c23c  \n",
       "3  575d33e9cf33c5a1bf3cb9a22eb5c23c  \n",
       "4  575d33e9cf33c5a1bf3cb9a22eb5c23c  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# df_qs = pd.DataFrame([ parse_qs(x) for x in df['query'] ])\n",
    "\n",
    "df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "print (df_qs.nunique())\n",
    "df_qs.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 建构行业参数模板\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['040'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c']}\n",
      "{'互联网/电商': '040', '游戏产业': '420', '计算机软件': '010', 'IT服务': '030', '电子/芯片/半导体': '050', '通信业': '060', '计算机/网络设备': '020', '房地产/建筑': '080', '规划/设计/装潢': '100', '房地产服务': '090', '银行': '130', '保险': '140', '基金/证券/投资': '150', '会计/审计': '430', '信托/担保/拍卖': '500', '快消品': '190', '批发零售': '240', '服装纺织': '200', '家具/家电': '210', '办公设备': '220', '奢侈品/收藏品': '460', '珠宝/玩具/工艺品': '470', '汽车/摩托车': '350', '机械/机电/重工': '360', '印刷/包装/造纸': '180', '原材料加工': '370', '仪器/电气/自动化': '340', '制药/生物工程': '270', '医疗/保健/美容': '280', '医疗器械': '290', '能源/水利': '330', '石油/化工': '310', '采掘/冶炼/矿产': '320', '环保': '300', '新能源': '490', '专业服务': '120', '中介服务': '110', '外包服务': '440', '检测/认证': '450', '餐饮/酒旅/服务': '230', '文体娱乐': '260', '租赁服务': '510', '广告/市场/会展': '070', '影视文化': '170', '教育培训': '380', '交通/物流/运输': '250', '贸易/进出口': '160', '航空/航天': '480', '政务/公共服务': '390', '农林牧渔': '410', '其他行业': '400'}\n"
     ]
    }
   ],
   "source": [
    "def parse_url_industries (url):\n",
    "    six_parts = urlparse(url) \n",
    "    out = parse_qs(six_parts.query)\n",
    "    return (out)\n",
    "\n",
    "参数模板 = parse_url_industries(list(行业数据链结.values())[0])\n",
    "print(参数模板)\n",
    "\n",
    "[ parse_url_industries(x)['industries'][0] for x in 行业数据链结.values()]\n",
    "\n",
    "字典_industries = { k:parse_url_industries(v)['industries'][0] for k,v in 行业数据链结.items()}\n",
    "print (字典_industries)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 查看产品经理的参数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'互联网/电商': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['040'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '游戏产业': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['420'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '计算机软件': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['010'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, 'IT服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['030'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '电子/芯片/半导体': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['050'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '通信业': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['060'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '计算机/网络设备': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['020'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '房地产/建筑': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['080'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '规划/设计/装潢': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['100'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '房地产服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['090'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '银行': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['130'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '保险': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['140'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '基金/证券/投资': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['150'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '会计/审计': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['430'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '信托/担保/拍卖': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['500'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '快消品': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['190'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '批发零售': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['240'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '服装纺织': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['200'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '家具/家电': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['210'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '办公设备': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['220'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '奢侈品/收藏品': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['460'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '珠宝/玩具/工艺品': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['470'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '汽车/摩托车': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['350'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '机械/机电/重工': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['360'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '印刷/包装/造纸': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['180'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '原材料加工': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['370'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '仪器/电气/自动化': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['340'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '制药/生物工程': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['270'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '医疗/保健/美容': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['280'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '医疗器械': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['290'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '能源/水利': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['330'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '石油/化工': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['310'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '采掘/冶炼/矿产': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['320'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '环保': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['300'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '新能源': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['490'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '专业服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['120'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '中介服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['110'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '外包服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['440'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '检测/认证': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['450'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '餐饮/酒旅/服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['230'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '文体娱乐': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['260'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '租赁服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['510'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '广告/市场/会展': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['070'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '影视文化': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['170'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '教育培训': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['380'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '交通/物流/运输': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['250'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '贸易/进出口': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['160'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '航空/航天': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['480'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '政务/公共服务': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['390'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '农林牧渔': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['410'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}, '其他行业': {'flushckid': ['1'], 'pageSize': ['40'], 'industryType': ['industry_01'], 'industries': ['400'], 'key': ['PRD'], 'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'], 'keyword': ['产品经理']}}"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "def 生成参数模板(industries, keyword ):\n",
    "    参数 = 参数模板.copy()\n",
    "    参数['industries'] = industries\n",
    "    参数['keyword'] = keyword\n",
    "    return (参数)\n",
    "\n",
    "产品经理_industries = { k:生成参数模板(industries = [v], keyword = ['产品经理']) for k,v in 字典_industries.items()}\n",
    "print(产品经理_industries)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 翻页参数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# A-0   单一页面\n",
    "url = \"https://www.liepin.com/zhaopin/?keyword=PRD\"\n",
    "session = HTMLSession()\n",
    "r = session.get( url )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[<Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=1'>, <Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=2'>, <Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=3'>, <Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=4'>, <Element 'a' href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=1'>, <Element 'a' class=('last',) href='/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=9' title='末页'>]\n",
      "{'2': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=1', '3': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=2', '4': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=3', '5': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=4', '下一页': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=1', '': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=9'}\n"
     ]
    }
   ],
   "source": [
    "# A-1  xpath 解析翻页a/@href\n",
    "xpath_翻页a = '//div[@class=\"pagerbar\"]/a' \n",
    "xpath_翻页a = '//div[@class=\"pagerbar\"]/a[starts-with(@href,\"/zhaopin\")]'\n",
    "print (r.html.xpath(xpath_翻页a)) \n",
    "\n",
    "href_列表 = [x.xpath('//@href')[0] for x in r.html.xpath(xpath_翻页a)]\n",
    "#print (href_列表)\n",
    "\n",
    "文字_列表 = [x.text for x in r.html.xpath(xpath_翻页a)]\n",
    "#print (文字_列表)\n",
    "\n",
    "href_字典 = {x.text:x.xpath('//@href')[0]  for x in r.html.xpath(xpath_翻页a)}\n",
    "print (href_字典)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 分析链接翻页链接，找到关键参数及参数结构\n",
    "#### 输入 href_列表, 建构出参数字典， urlparse 解析后载入数据框"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "from urllib.parse import urlparse, parse_qs\n",
    "import pandas as pd\n",
    "from IPython.display import display, HTML"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>scheme</th>\n",
       "      <th>netloc</th>\n",
       "      <th>path</th>\n",
       "      <th>params</th>\n",
       "      <th>query</th>\n",
       "      <th>fragment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>compkind=&amp;dqs=&amp;pubTime=&amp;pageSize=40&amp;salary=&amp;co...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  scheme netloc       path params  \\\n",
       "0                /zhaopin/          \n",
       "1                /zhaopin/          \n",
       "2                /zhaopin/          \n",
       "3                /zhaopin/          \n",
       "4                /zhaopin/          \n",
       "5                /zhaopin/          \n",
       "\n",
       "                                               query fragment  \n",
       "0  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "1  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "2  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "3  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "4  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           \n",
       "5  compkind=&dqs=&pubTime=&pageSize=40&salary=&co...           "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scheme      1\n",
      "netloc      1\n",
      "path        1\n",
      "params      1\n",
      "query       5\n",
      "fragment    1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pageSize</th>\n",
       "      <th>sortFlag</th>\n",
       "      <th>siTag</th>\n",
       "      <th>d_sfrom</th>\n",
       "      <th>d_ckId</th>\n",
       "      <th>d_curPage</th>\n",
       "      <th>d_pageSize</th>\n",
       "      <th>d_headId</th>\n",
       "      <th>curPage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>40</td>\n",
       "      <td>°radeFlag=0</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>714293f0e63ad74f460d562bfddcf2fc</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  pageSize     sortFlag                                          siTag  \\\n",
       "0       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "1       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "2       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "3       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "4       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "5       40  °radeFlag=0  1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw   \n",
       "\n",
       "          d_sfrom                            d_ckId d_curPage d_pageSize  \\\n",
       "0  search_unknown  714293f0e63ad74f460d562bfddcf2fc         0         40   \n",
       "1  search_unknown  714293f0e63ad74f460d562bfddcf2fc         0         40   \n",
       "2  search_unknown  714293f0e63ad74f460d562bfddcf2fc         0         40   \n",
       "3  search_unknown  714293f0e63ad74f460d562bfddcf2fc         0         40   \n",
       "4  search_unknown  714293f0e63ad74f460d562bfddcf2fc         0         40   \n",
       "5  search_unknown  714293f0e63ad74f460d562bfddcf2fc         0         40   \n",
       "\n",
       "                           d_headId curPage  \n",
       "0  714293f0e63ad74f460d562bfddcf2fc       1  \n",
       "1  714293f0e63ad74f460d562bfddcf2fc       2  \n",
       "2  714293f0e63ad74f460d562bfddcf2fc       3  \n",
       "3  714293f0e63ad74f460d562bfddcf2fc       4  \n",
       "4  714293f0e63ad74f460d562bfddcf2fc       1  \n",
       "5  714293f0e63ad74f460d562bfddcf2fc       9  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "pageSize      1\n",
      "sortFlag      1\n",
      "siTag         1\n",
      "d_sfrom       1\n",
      "d_ckId        1\n",
      "d_curPage     1\n",
      "d_pageSize    1\n",
      "d_headId      1\n",
      "curPage       5\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "df = pd.DataFrame([ urlparse(x) for x in href_列表])\n",
    "df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "\n",
    "display(df)\n",
    "print(df.nunique())\n",
    "display(df_qs)\n",
    "print(df_qs.nunique())\n",
    "\n",
    "df_qs.curPage\n",
    "df_qs = df_qs.assign (curPage_int=df_qs.curPage.astype(int)) "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 建构翻页参数模板：找到关键参数及参数结构"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'pageSize': ['40'], 'sortFlag': ['°radeFlag=0'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['714293f0e63ad74f460d562bfddcf2fc'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['714293f0e63ad74f460d562bfddcf2fc'], 'curPage': ['1']}\n",
      "{'2': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=1', '3': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=2', '4': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=3', '5': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=4', '下一页': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=1', '': '/zhaopin/?compkind=&dqs=&pubTime=&pageSize=40&salary=&compTag=&sortFlag=°radeFlag=0&compIds=&subIndustry=&jobKind=&industries=&compscale=&key=&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=714293f0e63ad74f460d562bfddcf2fc&d_curPage=0&d_pageSize=40&d_headId=714293f0e63ad74f460d562bfddcf2fc&curPage=9'}\n"
     ]
    }
   ],
   "source": [
    "def parse_url_qs_for_curPage (url):\n",
    "    six_parts = urlparse(url) \n",
    "    out = parse_qs(six_parts.query)\n",
    "    return (out)\n",
    "\n",
    "# 取一例做模板\n",
    "参数模板 = parse_url_qs_for_curPage(href_列表[0])\n",
    "print (参数模板)\n",
    "\n",
    "print (href_字典)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "9\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{0: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [0]},\n",
       " 1: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [1]},\n",
       " 2: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [2]},\n",
       " 3: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [3]},\n",
       " 4: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [4]},\n",
       " 5: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [5]},\n",
       " 6: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [6]},\n",
       " 7: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [7]},\n",
       " 8: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [8]},\n",
       " 9: {'flushckid': ['1'],\n",
       "  'pageSize': ['40'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'key': ['产品经理'],\n",
       "  'siTag': ['5pAulR6ffRIsqTOD3tZ_8w~fA9rXquZc5IkJpXC-Ycixw'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['575d33e9cf33c5a1bf3cb9a22eb5c23c'],\n",
       "  'curPage': [9]}}"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 构建参数模板\n",
    "def 参数模板生成(industryType,industries,curPage,key):\n",
    "    参数 = 参数模板.copy()\n",
    "    参数['industryType'] = industryType\n",
    "    参数['industries'] = industries\n",
    "    参数['curPage'] = curPage\n",
    "    参数['key'] = key\n",
    "    return (参数)\n",
    "\n",
    "print (df_qs.curPage_int.min()) \n",
    "print (df_qs.curPage_int.max()) \n",
    "\n",
    "# 最小页到最后页： 0 (本页)....9(最大值)\n",
    "\n",
    "参数_key_curPage = { \n",
    "    i:参数模板生成(industryType=['industry_01'],\\\n",
    "                       industries = ['040'],\\\n",
    "                      curPage = [i], \\\n",
    "                      key = ['产品经理']) \\\n",
    "    for i in range(0,df_qs.curPage_int.max()+1)\\\n",
    "    }\n",
    "参数_key_curPage"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 爬取的数据模板建构\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "session = HTMLSession()\n",
    "\n",
    "def requests_liepin( url, params):\n",
    "    r = session.get( url , params = payload)\n",
    "\n",
    "    # 先取特定元素, 精准打击其子后辈\n",
    "    主要元素 = r.html.xpath( '//ul[@class=\"sojob-list\"]/li')\n",
    "\n",
    "    # 作为xpath字典，键为我要抓的牛肉名称，值为xpath\n",
    "    dict_xpaths={ \n",
    "        'text': {\n",
    "            '学历':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]',\n",
    "            '经验':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]/following-sibling::span',\n",
    "            '薪水':    '//div[contains(@class,\"job-info\")]/p/span[@class=\"text-warning\"]', \n",
    "            '时间':    '//div[contains(@class,\"job-info\")]/p/time/@title', \n",
    "            '职称':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司地点': '//div[contains(@class,\"job-info\")]/p/a',\n",
    "            '公司名称': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        },\n",
    "        'text_content': {\n",
    "        },\n",
    "        'href': {\n",
    "            '链接':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司URL': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        }\n",
    "    }\n",
    "\n",
    "    def get_e_text_content(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [e.xpath(_xpath_)[0].lxml.text_content() for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_text(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [\"\".join([x.strip() if type(x) is str else x.text.strip() for x in e.xpath(_xpath_)]) for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_href(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [list(e.xpath(_xpath_, first=True).absolute_links)[0] \\\n",
    "                   if len(e.xpath(_xpath_, first=True).absolute_links) >= 1  \\\n",
    "                   else \"\" for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    # 只对主要元素下进行.xpath取值\n",
    "    数据字典 = dict()\n",
    "\n",
    "    数据字典 = {k:get_e_text_content(v) for k,v in dict_xpaths['text_content'].items()}\n",
    "    数据字典.update({k:get_e_text(v) for k,v in dict_xpaths['text'].items()})\n",
    "    数据字典.update({k:get_e_href(v) for k,v in dict_xpaths['href'].items()})\n",
    "\n",
    " \n",
    "\n",
    "    数据 = pd.DataFrame(数据字典)\n",
    "#     数据.to_csv(\"2020web数据挖掘数据.tsv\", index=False, sep='\\t', encoding='utf-8')\n",
    "#     数据.to_excel(\"2020web数据挖掘数据+.xlsx\", sheet_name=\"搜查结果\")\n",
    "    return (数据) "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 数据表输出-变量：行业，翻页"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "用户研究 10\n",
      "UI设计 10\n",
      "产品经理 10\n",
      "新媒体运营 10\n",
      "前端开发 10\n",
      "Wall time: 5min 16s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "# 多个页面+多个关键词\n",
    "import time\n",
    "from random import random\n",
    "\n",
    "url = \"https://www.liepin.com/zhaopin/\"\n",
    "xpath_翻页a = '//div[@class=\"pagerbar\"]/a[starts-with(@href,\"/zhaopin\")]'\n",
    "\n",
    "keywords = ['用户研究','UI设计','产品经理','新媒体运营','前端开发']\n",
    "list_df = list()\n",
    "\n",
    "# 选定行业类型为广告·传媒·教育·文化，行业为广告/市场/会展\n",
    "for key in keywords:\n",
    "    payload = 参数模板生成(industryType=['industry_01'],industries = ['040'],key=[key], curPage=['0'])\n",
    "    df = requests_liepin( url, params = payload)\n",
    "    href_列表 = [x.xpath('//@href')[0] for x in r.html.xpath(xpath_翻页a)]\n",
    "    df = pd.DataFrame([ urlparse(x) for x in href_列表])\n",
    "    df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "    df_qs = df_qs.assign (curPage_int=df_qs.curPage.astype(int)) \n",
    "    长度 = df_qs.curPage_int.max()+1\n",
    "    参数_keyword_X_curPage = { \n",
    "        i:参数模板生成(industryType=['industry_02'],\\\n",
    "                       industries = ['060'],\\\n",
    "                      curPage = [i], \\\n",
    "                      key = [key]) \\\n",
    "        for i in range(0,长度)\\\n",
    "        }\n",
    "    print (key,长度)#10\n",
    "    \n",
    "    for k,v in 参数_keyword_X_curPage.items():\n",
    "        payload = v\n",
    "        df = requests_liepin( url, params = payload)\n",
    "        time.sleep(3+4*random())  #放慢脚步 3-7秒, 平均约5秒\n",
    "        df = df.assign (行业类型 = '广告·传媒·教育·文化' )\n",
    "        df = df.assign (行业 = '影视文化')\n",
    "        df = df.assign (关键词 = key)  # 区分  keyword    \n",
    "        df = df.assign (页数 = k)  # 区分  curPage    \n",
    "        list_df.append(df)\n",
    "        \n",
    "df_all = pd.concat(list_df).reset_index()\n",
    "df_all.index.name = '序'\n",
    "\n",
    "# 数据导出\n",
    "df_all.to_excel(\"2020_Web数据挖掘_liepin_广告·传媒·教育·文化_翻页合集.xlsx\",\\\n",
    "                sheet_name=\"_\".join(keywords))\n",
    "# 预估时间: 4*5秒*10 =200\n",
    "# 预估数量: 4*40*10 =1600"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>时间</th>\n",
       "      <th>职称</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司URL</th>\n",
       "      <th>行业类型</th>\n",
       "      <th>行业</th>\n",
       "      <th>关键词</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>序</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>8-11k·12薪</td>\n",
       "      <td>2020年10月26日</td>\n",
       "      <td>高级用户体验研究员（用户研究岗）</td>\n",
       "      <td>北京</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>https://www.liepin.com/job/1927446107.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9122701/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>用户研究</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>20-35k·12薪</td>\n",
       "      <td>2020年10月26日</td>\n",
       "      <td>用户体验高级研究员</td>\n",
       "      <td>北京</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>https://www.liepin.com/job/1920864427.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9122701/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>用户研究</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>16-32k·13薪</td>\n",
       "      <td>2020年10月26日</td>\n",
       "      <td>用户市场高级研究员</td>\n",
       "      <td>北京-广安门</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>https://www.liepin.com/job/1920864247.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9122701/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>用户研究</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>2020年10月22日</td>\n",
       "      <td>用户研究岗</td>\n",
       "      <td>深圳</td>\n",
       "      <td>中移信息技术有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1932693523.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8385580/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>用户研究</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>15-30k·12薪</td>\n",
       "      <td>2020年10月08日</td>\n",
       "      <td>用户研究经理(006751)</td>\n",
       "      <td>深圳-新安</td>\n",
       "      <td>vivo</td>\n",
       "      <td>https://www.liepin.com/job/1926400715.shtml</td>\n",
       "      <td>https://www.liepin.com/company/4787049/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>用户研究</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1753</th>\n",
       "      <td>35</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>2020年04月29日</td>\n",
       "      <td>Web前端开发工程师（XA）</td>\n",
       "      <td>西安-未央区</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927870591.shtml</td>\n",
       "      <td>https://www.liepin.com/company/554892/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>前端开发</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1754</th>\n",
       "      <td>36</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-15k·14薪</td>\n",
       "      <td>2020年04月28日</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>南京-雨花台区</td>\n",
       "      <td>桑达实业</td>\n",
       "      <td>https://www.liepin.com/job/1927857951.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7871087/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>前端开发</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1755</th>\n",
       "      <td>37</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>2020年04月28日</td>\n",
       "      <td>前端开发工程师（REACT）</td>\n",
       "      <td>苏州</td>\n",
       "      <td>亨通</td>\n",
       "      <td>https://www.liepin.com/job/1927856955.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7991650/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>前端开发</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1756</th>\n",
       "      <td>38</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月28日</td>\n",
       "      <td>web前端开发工程师</td>\n",
       "      <td>大连</td>\n",
       "      <td>北京南邮信息技术有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1926083925.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9792965/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>前端开发</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1757</th>\n",
       "      <td>39</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>12-16k·12薪</td>\n",
       "      <td>2020年04月23日</td>\n",
       "      <td>前端开发工程师（驻点数字广东）</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927676313.shtml</td>\n",
       "      <td>https://www.liepin.com/company/554892/</td>\n",
       "      <td>广告·传媒·教育·文化</td>\n",
       "      <td>影视文化</td>\n",
       "      <td>前端开发</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1758 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      index     学历     经验          薪水           时间                职称     公司地点  \\\n",
       "序                                                                               \n",
       "0         0  硕士及以上  5-10年   8-11k·12薪  2020年10月26日  高级用户体验研究员（用户研究岗）       北京   \n",
       "1         1  硕士及以上  5-10年  20-35k·12薪  2020年10月26日         用户体验高级研究员       北京   \n",
       "2         2  硕士及以上  5-10年  16-32k·13薪  2020年10月26日         用户市场高级研究员   北京-广安门   \n",
       "3         3  本科及以上   3-5年  15-25k·12薪  2020年10月22日             用户研究岗       深圳   \n",
       "4         4   学历不限   1-3年  15-30k·12薪  2020年10月08日    用户研究经理(006751)    深圳-新安   \n",
       "...     ...    ...    ...         ...          ...               ...      ...   \n",
       "1753     35  大专及以上   3-5年  10-15k·12薪  2020年04月29日    Web前端开发工程师（XA）   西安-未央区   \n",
       "1754     36  本科及以上   3-5年   8-15k·14薪  2020年04月28日           前端开发工程师  南京-雨花台区   \n",
       "1755     37  大专及以上   3-5年  10-15k·12薪  2020年04月28日    前端开发工程师（REACT）       苏州   \n",
       "1756     38  大专及以上   3-5年    6-8k·12薪  2020年04月28日        web前端开发工程师       大连   \n",
       "1757     39  大专及以上   3-5年  12-16k·12薪  2020年04月23日   前端开发工程师（驻点数字广东）   广州-越秀区   \n",
       "\n",
       "               公司名称                                           链接  \\\n",
       "序                                                                  \n",
       "0     中国移动通信有限公司研究院  https://www.liepin.com/job/1927446107.shtml   \n",
       "1     中国移动通信有限公司研究院  https://www.liepin.com/job/1920864427.shtml   \n",
       "2     中国移动通信有限公司研究院  https://www.liepin.com/job/1920864247.shtml   \n",
       "3        中移信息技术有限公司  https://www.liepin.com/job/1932693523.shtml   \n",
       "4              vivo  https://www.liepin.com/job/1926400715.shtml   \n",
       "...             ...                                          ...   \n",
       "1753     彩讯科技股份有限公司  https://www.liepin.com/job/1927870591.shtml   \n",
       "1754           桑达实业  https://www.liepin.com/job/1927857951.shtml   \n",
       "1755             亨通  https://www.liepin.com/job/1927856955.shtml   \n",
       "1756   北京南邮信息技术有限公司  https://www.liepin.com/job/1926083925.shtml   \n",
       "1757     彩讯科技股份有限公司  https://www.liepin.com/job/1927676313.shtml   \n",
       "\n",
       "                                        公司URL         行业类型    行业   关键词  页数  \n",
       "序                                                                           \n",
       "0     https://www.liepin.com/company/9122701/  广告·传媒·教育·文化  影视文化  用户研究   0  \n",
       "1     https://www.liepin.com/company/9122701/  广告·传媒·教育·文化  影视文化  用户研究   0  \n",
       "2     https://www.liepin.com/company/9122701/  广告·传媒·教育·文化  影视文化  用户研究   0  \n",
       "3     https://www.liepin.com/company/8385580/  广告·传媒·教育·文化  影视文化  用户研究   0  \n",
       "4     https://www.liepin.com/company/4787049/  广告·传媒·教育·文化  影视文化  用户研究   0  \n",
       "...                                       ...          ...   ...   ...  ..  \n",
       "1753   https://www.liepin.com/company/554892/  广告·传媒·教育·文化  影视文化  前端开发   9  \n",
       "1754  https://www.liepin.com/company/7871087/  广告·传媒·教育·文化  影视文化  前端开发   9  \n",
       "1755  https://www.liepin.com/company/7991650/  广告·传媒·教育·文化  影视文化  前端开发   9  \n",
       "1756  https://www.liepin.com/company/9792965/  广告·传媒·教育·文化  影视文化  前端开发   9  \n",
       "1757   https://www.liepin.com/company/554892/  广告·传媒·教育·文化  影视文化  前端开发   9  \n",
       "\n",
       "[1758 rows x 14 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>关键词</th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>序</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>高级用户体验研究员（用户研究岗）</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>8-11k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927446107.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>用户体验高级研究员</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>20-35k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1920864427.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>用户市场高级研究员</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>16-32k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1920864247.shtml</td>\n",
       "      <td>北京-广安门</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>用户研究岗</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932693523.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>中移信息技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>用户研究经理(006751)</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>15-30k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926400715.shtml</td>\n",
       "      <td>深圳-新安</td>\n",
       "      <td>vivo</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1753</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>Web前端开发工程师（XA）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927870591.shtml</td>\n",
       "      <td>西安-未央区</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1754</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-15k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1927857951.shtml</td>\n",
       "      <td>南京-雨花台区</td>\n",
       "      <td>桑达实业</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1755</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师（REACT）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927856955.shtml</td>\n",
       "      <td>苏州</td>\n",
       "      <td>亨通</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1756</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>web前端开发工程师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926083925.shtml</td>\n",
       "      <td>大连</td>\n",
       "      <td>北京南邮信息技术有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1757</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师（驻点数字广东）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>12-16k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927676313.shtml</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1758 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       关键词                职称     学历     经验          薪水  \\\n",
       "序                                                        \n",
       "0     用户研究  高级用户体验研究员（用户研究岗）  硕士及以上  5-10年   8-11k·12薪   \n",
       "1     用户研究         用户体验高级研究员  硕士及以上  5-10年  20-35k·12薪   \n",
       "2     用户研究         用户市场高级研究员  硕士及以上  5-10年  16-32k·13薪   \n",
       "3     用户研究             用户研究岗  本科及以上   3-5年  15-25k·12薪   \n",
       "4     用户研究    用户研究经理(006751)   学历不限   1-3年  15-30k·12薪   \n",
       "...    ...               ...    ...    ...         ...   \n",
       "1753  前端开发    Web前端开发工程师（XA）  大专及以上   3-5年  10-15k·12薪   \n",
       "1754  前端开发           前端开发工程师  本科及以上   3-5年   8-15k·14薪   \n",
       "1755  前端开发    前端开发工程师（REACT）  大专及以上   3-5年  10-15k·12薪   \n",
       "1756  前端开发        web前端开发工程师  大专及以上   3-5年    6-8k·12薪   \n",
       "1757  前端开发   前端开发工程师（驻点数字广东）  大专及以上   3-5年  12-16k·12薪   \n",
       "\n",
       "                                               链接     公司地点           公司名称  页数  \n",
       "序                                                                              \n",
       "0     https://www.liepin.com/job/1927446107.shtml       北京  中国移动通信有限公司研究院   0  \n",
       "1     https://www.liepin.com/job/1920864427.shtml       北京  中国移动通信有限公司研究院   0  \n",
       "2     https://www.liepin.com/job/1920864247.shtml   北京-广安门  中国移动通信有限公司研究院   0  \n",
       "3     https://www.liepin.com/job/1932693523.shtml       深圳     中移信息技术有限公司   0  \n",
       "4     https://www.liepin.com/job/1926400715.shtml    深圳-新安           vivo   0  \n",
       "...                                           ...      ...            ...  ..  \n",
       "1753  https://www.liepin.com/job/1927870591.shtml   西安-未央区     彩讯科技股份有限公司   9  \n",
       "1754  https://www.liepin.com/job/1927857951.shtml  南京-雨花台区           桑达实业   9  \n",
       "1755  https://www.liepin.com/job/1927856955.shtml       苏州             亨通   9  \n",
       "1756  https://www.liepin.com/job/1926083925.shtml       大连   北京南邮信息技术有限公司   9  \n",
       "1757  https://www.liepin.com/job/1927676313.shtml   广州-越秀区     彩讯科技股份有限公司   9  \n",
       "\n",
       "[1758 rows x 9 columns]"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all_1 = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']]\n",
    "df_all_1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 筛选出用户研究的数据\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>高级用户体验研究员（用户研究岗）</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>8-11k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927446107.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>用户体验高级研究员</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>20-35k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1920864427.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>用户市场高级研究员</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>16-32k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1920864247.shtml</td>\n",
       "      <td>北京-广安门</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>用户研究岗</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932693523.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>中移信息技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>用户研究经理(006751)</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>15-30k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926400715.shtml</td>\n",
       "      <td>深圳-新安</td>\n",
       "      <td>vivo</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>市场经理</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928823297.shtml</td>\n",
       "      <td>兰州</td>\n",
       "      <td>华为</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>云计算培训认证产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927931057.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>新华三集团</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>IT（服务器、存储）培训认证产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927930253.shtml</td>\n",
       "      <td>杭州</td>\n",
       "      <td>新华三集团</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>IT（服务器、存储）培训认证产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927930251.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>新华三集团</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>用户研究</th>\n",
       "      <td>产品经理-游戏</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1926558993.shtml</td>\n",
       "      <td>上海-浦东新区</td>\n",
       "      <td>传音控股</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      职称     学历     经验          薪水  \\\n",
       "关键词                                                  \n",
       "用户研究    高级用户体验研究员（用户研究岗）  硕士及以上  5-10年   8-11k·12薪   \n",
       "用户研究           用户体验高级研究员  硕士及以上  5-10年  20-35k·12薪   \n",
       "用户研究           用户市场高级研究员  硕士及以上  5-10年  16-32k·13薪   \n",
       "用户研究               用户研究岗  本科及以上   3-5年  15-25k·12薪   \n",
       "用户研究      用户研究经理(006751)   学历不限   1-3年  15-30k·12薪   \n",
       "...                  ...    ...    ...         ...   \n",
       "用户研究                市场经理  大专及以上   3-5年  10-15k·12薪   \n",
       "用户研究         云计算培训认证产品经理   统招本科   3-5年  10-15k·12薪   \n",
       "用户研究  IT（服务器、存储）培训认证产品经理   统招本科   3-5年  10-15k·12薪   \n",
       "用户研究  IT（服务器、存储）培训认证产品经理   统招本科   3-5年  10-15k·12薪   \n",
       "用户研究             产品经理-游戏  本科及以上   3-5年          面议   \n",
       "\n",
       "                                               链接     公司地点           公司名称  页数  \n",
       "关键词                                                                            \n",
       "用户研究  https://www.liepin.com/job/1927446107.shtml       北京  中国移动通信有限公司研究院   0  \n",
       "用户研究  https://www.liepin.com/job/1920864427.shtml       北京  中国移动通信有限公司研究院   0  \n",
       "用户研究  https://www.liepin.com/job/1920864247.shtml   北京-广安门  中国移动通信有限公司研究院   0  \n",
       "用户研究  https://www.liepin.com/job/1932693523.shtml       深圳     中移信息技术有限公司   0  \n",
       "用户研究  https://www.liepin.com/job/1926400715.shtml    深圳-新安           vivo   0  \n",
       "...                                           ...      ...            ...  ..  \n",
       "用户研究  https://www.liepin.com/job/1928823297.shtml       兰州             华为   9  \n",
       "用户研究  https://www.liepin.com/job/1927931057.shtml       北京          新华三集团   9  \n",
       "用户研究  https://www.liepin.com/job/1927930253.shtml       杭州          新华三集团   9  \n",
       "用户研究  https://www.liepin.com/job/1927930251.shtml       北京          新华三集团   9  \n",
       "用户研究  https://www.liepin.com/job/1926558993.shtml  上海-浦东新区           传音控股   9  \n",
       "\n",
       "[400 rows x 8 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_User_Research = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['用户研究']\n",
    "df_User_Research.to_excel(\"影视文化_用户研究.xlsx\",\\\n",
    "                sheet_name=\"影视文化_用户研究\")\n",
    "df_User_Research"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 筛选出ui设计的数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>UI设计师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1930927879.shtml</td>\n",
       "      <td>杭州-金家渡</td>\n",
       "      <td>亿邦股份</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>ui设计</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>6-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1925162677.shtml</td>\n",
       "      <td>佛山-顺德区</td>\n",
       "      <td>广东顺德中电信息技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>UI/界面设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>13-20k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1932768467.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>广州智讯通信系统有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>高级ui设计师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932529093.shtml</td>\n",
       "      <td>深圳-宝安区</td>\n",
       "      <td>深圳市元道通信技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>UI设计师-北京</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923032381.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>杭州迪普科技股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>Java Principal Developer</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1910416323.shtml</td>\n",
       "      <td></td>\n",
       "      <td>Tangent International Limited</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>Java Principal Developer</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1910416322.shtml</td>\n",
       "      <td></td>\n",
       "      <td>Tangent International Limited</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>android工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>9-13k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932193763.shtml</td>\n",
       "      <td>成都</td>\n",
       "      <td>成都国星宇航科技有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>UE交互设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1921080805.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>酷派集团</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UI设计</th>\n",
       "      <td>高级前端工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>7-11k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1931535753.shtml</td>\n",
       "      <td>青岛</td>\n",
       "      <td>山东亚华电子股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            职称     学历     经验          薪水  \\\n",
       "关键词                                                        \n",
       "UI设计                     UI设计师  大专及以上  5-10年  10-15k·12薪   \n",
       "UI设计                      ui设计   学历不限   经验不限   6-12k·12薪   \n",
       "UI设计                  UI/界面设计师  本科及以上   经验不限  13-20k·14薪   \n",
       "UI设计                   高级ui设计师  大专及以上   3-5年   8-15k·12薪   \n",
       "UI设计                  UI设计师-北京   统招本科   1-3年  10-20k·12薪   \n",
       "...                        ...    ...    ...         ...   \n",
       "UI设计  Java Principal Developer  大专及以上  5-10年          面议   \n",
       "UI设计  Java Principal Developer  大专及以上  5-10年          面议   \n",
       "UI设计                android工程师  本科及以上  5-10年   9-13k·12薪   \n",
       "UI设计                   UE交互设计师  本科及以上   3-5年  15-20k·12薪   \n",
       "UI设计                   高级前端工程师  本科及以上  5-10年   7-11k·12薪   \n",
       "\n",
       "                                               链接    公司地点  \\\n",
       "关键词                                                         \n",
       "UI设计  https://www.liepin.com/job/1930927879.shtml  杭州-金家渡   \n",
       "UI设计  https://www.liepin.com/job/1925162677.shtml  佛山-顺德区   \n",
       "UI设计  https://www.liepin.com/job/1932768467.shtml      北京   \n",
       "UI设计  https://www.liepin.com/job/1932529093.shtml  深圳-宝安区   \n",
       "UI设计  https://www.liepin.com/job/1923032381.shtml      北京   \n",
       "...                                           ...     ...   \n",
       "UI设计  https://www.liepin.com/job/1910416323.shtml           \n",
       "UI设计  https://www.liepin.com/job/1910416322.shtml           \n",
       "UI设计  https://www.liepin.com/job/1932193763.shtml      成都   \n",
       "UI设计  https://www.liepin.com/job/1921080805.shtml      深圳   \n",
       "UI设计  https://www.liepin.com/job/1931535753.shtml      青岛   \n",
       "\n",
       "                               公司名称  页数  \n",
       "关键词                                      \n",
       "UI设计                           亿邦股份   0  \n",
       "UI设计                 广东顺德中电信息技术有限公司   0  \n",
       "UI设计                   广州智讯通信系统有限公司   0  \n",
       "UI设计                  深圳市元道通信技术有限公司   0  \n",
       "UI设计                   杭州迪普科技股份有限公司   0  \n",
       "...                             ...  ..  \n",
       "UI设计  Tangent International Limited   9  \n",
       "UI设计  Tangent International Limited   9  \n",
       "UI设计                   成都国星宇航科技有限公司   9  \n",
       "UI设计                           酷派集团   9  \n",
       "UI设计                   山东亚华电子股份有限公司   9  \n",
       "\n",
       "[400 rows x 8 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ui = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['UI设计']\n",
    "df_ui.to_excel(\"影视文化_UI设计.xlsx\",\\\n",
    "                 sheet_name=\"影视文化_UI设计\")\n",
    "df_ui"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 筛选出产品经理的数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>高级物联网产品经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>20-35k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932865439.shtml</td>\n",
       "      <td>上海</td>\n",
       "      <td>新智认知</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>高级产品经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>25-50k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932853807.shtml</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>传音控股</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932806265.shtml</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>深圳博瑞天下科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>产品运营经理（智慧云） (职位编号：CMRI001437)</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-30k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932786255.shtml</td>\n",
       "      <td>北京</td>\n",
       "      <td>中国移动通信有限公司研究院</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>策略产品经理</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932562673.shtml</td>\n",
       "      <td>苏州</td>\n",
       "      <td>三邦智能科技(苏州)有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932751097.shtml</td>\n",
       "      <td>上海-长宁区</td>\n",
       "      <td>希姆通信息技术(上海)有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>通信产品区域销售经理</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932745751.shtml</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>润建股份</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>产品销售部总经理（运营商业务）</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>25-35k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1931846309.shtml</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>润建股份</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>通信产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>6-10k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1931476277.shtml</td>\n",
       "      <td>广州</td>\n",
       "      <td>京信通信系统(中国)有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>售前产品经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1931385887.shtml</td>\n",
       "      <td></td>\n",
       "      <td>深圳国人无线通信有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 职称     学历     经验          薪水  \\\n",
       "关键词                                                             \n",
       "产品经理                      高级物联网产品经理  本科及以上  5-10年  20-35k·12薪   \n",
       "产品经理                         高级产品经理  本科及以上  5-10年  25-50k·12薪   \n",
       "产品经理                           产品经理   统招本科   1-3年  10-15k·12薪   \n",
       "产品经理  产品运营经理（智慧云） (职位编号：CMRI001437)  本科及以上   3-5年  15-30k·12薪   \n",
       "产品经理                         策略产品经理  大专及以上   经验不限   8-12k·12薪   \n",
       "...                             ...    ...    ...         ...   \n",
       "产品经理                           产品经理  本科及以上   3-5年  10-15k·12薪   \n",
       "产品经理                     通信产品区域销售经理  大专及以上   3-5年  15-25k·12薪   \n",
       "产品经理                产品销售部总经理（运营商业务）  本科及以上  5-10年  25-35k·12薪   \n",
       "产品经理                         通信产品经理   统招本科   3-5年   6-10k·14薪   \n",
       "产品经理                         售前产品经理  本科及以上   3-5年  10-15k·12薪   \n",
       "\n",
       "                                               链接    公司地点             公司名称  页数  \n",
       "关键词                                                                             \n",
       "产品经理  https://www.liepin.com/job/1932865439.shtml      上海             新智认知   0  \n",
       "产品经理  https://www.liepin.com/job/1932853807.shtml  深圳-南山区             传音控股   0  \n",
       "产品经理  https://www.liepin.com/job/1932806265.shtml  广州-海珠区     深圳博瑞天下科技有限公司   0  \n",
       "产品经理  https://www.liepin.com/job/1932786255.shtml      北京    中国移动通信有限公司研究院   0  \n",
       "产品经理  https://www.liepin.com/job/1932562673.shtml      苏州   三邦智能科技(苏州)有限公司   0  \n",
       "...                                           ...     ...              ...  ..  \n",
       "产品经理  https://www.liepin.com/job/1932751097.shtml  上海-长宁区  希姆通信息技术(上海)有限公司   9  \n",
       "产品经理  https://www.liepin.com/job/1932745751.shtml  广州-海珠区             润建股份   9  \n",
       "产品经理  https://www.liepin.com/job/1931846309.shtml  广州-海珠区             润建股份   9  \n",
       "产品经理  https://www.liepin.com/job/1931476277.shtml      广州   京信通信系统(中国)有限公司   9  \n",
       "产品经理  https://www.liepin.com/job/1931385887.shtml             深圳国人无线通信有限公司   9  \n",
       "\n",
       "[400 rows x 8 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_PM = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['产品经理']\n",
    "df_PM.to_excel(\"影视文化_产品经理.xlsx\",\\\n",
    "                 sheet_name=\"影视文化_产品经理\")\n",
    "df_PM"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 筛选出新媒体运营的数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>新媒体运营</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932023755.shtml</td>\n",
       "      <td>长沙-咸嘉湖</td>\n",
       "      <td>高新兴智联科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>海外新媒体运营</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-13k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1930964513.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>传音控股</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>新媒体运营主管</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-10k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927314755.shtml</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>中鹏云控股(深圳)有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>新媒体运营专员（南山-科苑）</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1925191887.shtml</td>\n",
       "      <td>深圳-科技园</td>\n",
       "      <td>中鹏云控股(深圳)有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>新媒体运营经理（视频方向）</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1926725231.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>华为</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>资深文案</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1919909843.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>海翼电商</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>运营经理</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1919506389.shtml</td>\n",
       "      <td>厦门-集美区</td>\n",
       "      <td>厦门英特易信息科技股份有限公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>新媒体项目运营总监</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-20k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1918970661.shtml</td>\n",
       "      <td>江门</td>\n",
       "      <td>东莞市润熹数码电子有限公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>产品营销经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-30k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1918488415.shtml</td>\n",
       "      <td>东莞</td>\n",
       "      <td>vivo</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新媒体运营</th>\n",
       "      <td>市场总监</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1916909311.shtml</td>\n",
       "      <td>厦门</td>\n",
       "      <td>译翼通(厦门)科技有限公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>158 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   职称     学历    经验          薪水  \\\n",
       "关键词                                              \n",
       "新媒体运营           新媒体运营  本科及以上  经验不限    6-8k·12薪   \n",
       "新媒体运营         海外新媒体运营   统招本科  3-5年   8-13k·14薪   \n",
       "新媒体运营         新媒体运营主管   统招本科  3-5年   8-10k·12薪   \n",
       "新媒体运营  新媒体运营专员（南山-科苑）  本科及以上  3-5年    6-8k·12薪   \n",
       "新媒体运营   新媒体运营经理（视频方向）   统招本科  经验不限          面议   \n",
       "...               ...    ...   ...         ...   \n",
       "新媒体运营            资深文案  本科及以上  3-5年  15-20k·12薪   \n",
       "新媒体运营            运营经理  大专及以上  3-5年  10-20k·12薪   \n",
       "新媒体运营       新媒体项目运营总监   统招本科  1-3年  10-20k·14薪   \n",
       "新媒体运营          产品营销经理  本科及以上  3-5年  15-30k·12薪   \n",
       "新媒体运营            市场总监  本科及以上  1-3年   8-15k·12薪   \n",
       "\n",
       "                                                链接    公司地点             公司名称  \\\n",
       "关键词                                                                           \n",
       "新媒体运营  https://www.liepin.com/job/1932023755.shtml  长沙-咸嘉湖      高新兴智联科技有限公司   \n",
       "新媒体运营  https://www.liepin.com/job/1930964513.shtml      深圳             传音控股   \n",
       "新媒体运营  https://www.liepin.com/job/1927314755.shtml  深圳-南山区    中鹏云控股(深圳)有限公司   \n",
       "新媒体运营  https://www.liepin.com/job/1925191887.shtml  深圳-科技园    中鹏云控股(深圳)有限公司   \n",
       "新媒体运营  https://www.liepin.com/job/1926725231.shtml      深圳               华为   \n",
       "...                                            ...     ...              ...   \n",
       "新媒体运营  https://www.liepin.com/job/1919909843.shtml      深圳             海翼电商   \n",
       "新媒体运营  https://www.liepin.com/job/1919506389.shtml  厦门-集美区  厦门英特易信息科技股份有限公司   \n",
       "新媒体运营  https://www.liepin.com/job/1918970661.shtml      江门    东莞市润熹数码电子有限公司   \n",
       "新媒体运营  https://www.liepin.com/job/1918488415.shtml      东莞             vivo   \n",
       "新媒体运营  https://www.liepin.com/job/1916909311.shtml      厦门    译翼通(厦门)科技有限公司   \n",
       "\n",
       "       页数  \n",
       "关键词        \n",
       "新媒体运营   0  \n",
       "新媒体运营   0  \n",
       "新媒体运营   0  \n",
       "新媒体运营   0  \n",
       "新媒体运营   0  \n",
       "...    ..  \n",
       "新媒体运营   3  \n",
       "新媒体运营   3  \n",
       "新媒体运营   3  \n",
       "新媒体运营   3  \n",
       "新媒体运营   3  \n",
       "\n",
       "[158 rows x 8 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_New_Medium = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['新媒体运营']\n",
    "df_New_Medium.to_excel(\"影视文化_新媒体运营.xlsx\",\\\n",
    "                sheet_name=\"影视文化_新媒体运营\")\n",
    "df_New_Medium"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 筛选出前端开发的数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关键词</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>web前端开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1932840917.shtml</td>\n",
       "      <td>深圳</td>\n",
       "      <td>华普特科技(深圳)股份有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-13k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932786455.shtml</td>\n",
       "      <td>赣州</td>\n",
       "      <td>金信诺</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>前端开发高级工程师（广州）</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>18-35k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1932661945.shtml</td>\n",
       "      <td>广州</td>\n",
       "      <td>亚信科技</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>web前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932360299.shtml</td>\n",
       "      <td>武汉-江夏区</td>\n",
       "      <td>武汉大塔技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>web前端开发工程师 校招</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932050409.shtml</td>\n",
       "      <td>上海</td>\n",
       "      <td>海隆石油集团(上海)信息技术有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>Web前端开发工程师（XA）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927870591.shtml</td>\n",
       "      <td>西安-未央区</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-15k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1927857951.shtml</td>\n",
       "      <td>南京-雨花台区</td>\n",
       "      <td>桑达实业</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>前端开发工程师（REACT）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927856955.shtml</td>\n",
       "      <td>苏州</td>\n",
       "      <td>亨通</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>web前端开发工程师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1926083925.shtml</td>\n",
       "      <td>大连</td>\n",
       "      <td>北京南邮信息技术有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>前端开发</th>\n",
       "      <td>前端开发工程师（驻点数字广东）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>12-16k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927676313.shtml</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   职称     学历     经验          薪水  \\\n",
       "关键词                                               \n",
       "前端开发       web前端开发工程师  本科及以上   3-5年  10-15k·14薪   \n",
       "前端开发          前端开发工程师  大专及以上   1-3年   8-13k·12薪   \n",
       "前端开发    前端开发高级工程师（广州）   统招本科   3-5年  18-35k·13薪   \n",
       "前端开发       web前端开发工程师   统招本科   1-3年  10-15k·12薪   \n",
       "前端开发    web前端开发工程师 校招  本科及以上  5-10年  10-15k·12薪   \n",
       "...               ...    ...    ...         ...   \n",
       "前端开发   Web前端开发工程师（XA）  大专及以上   3-5年  10-15k·12薪   \n",
       "前端开发          前端开发工程师  本科及以上   3-5年   8-15k·14薪   \n",
       "前端开发   前端开发工程师（REACT）  大专及以上   3-5年  10-15k·12薪   \n",
       "前端开发       web前端开发工程师  大专及以上   3-5年    6-8k·12薪   \n",
       "前端开发  前端开发工程师（驻点数字广东）  大专及以上   3-5年  12-16k·12薪   \n",
       "\n",
       "                                               链接     公司地点  \\\n",
       "关键词                                                          \n",
       "前端开发  https://www.liepin.com/job/1932840917.shtml       深圳   \n",
       "前端开发  https://www.liepin.com/job/1932786455.shtml       赣州   \n",
       "前端开发  https://www.liepin.com/job/1932661945.shtml       广州   \n",
       "前端开发  https://www.liepin.com/job/1932360299.shtml   武汉-江夏区   \n",
       "前端开发  https://www.liepin.com/job/1932050409.shtml       上海   \n",
       "...                                           ...      ...   \n",
       "前端开发  https://www.liepin.com/job/1927870591.shtml   西安-未央区   \n",
       "前端开发  https://www.liepin.com/job/1927857951.shtml  南京-雨花台区   \n",
       "前端开发  https://www.liepin.com/job/1927856955.shtml       苏州   \n",
       "前端开发  https://www.liepin.com/job/1926083925.shtml       大连   \n",
       "前端开发  https://www.liepin.com/job/1927676313.shtml   广州-越秀区   \n",
       "\n",
       "                    公司名称  页数  \n",
       "关键词                           \n",
       "前端开发     华普特科技(深圳)股份有限公司   0  \n",
       "前端开发                 金信诺   0  \n",
       "前端开发                亚信科技   0  \n",
       "前端开发          武汉大塔技术有限公司   0  \n",
       "前端开发  海隆石油集团(上海)信息技术有限公司   0  \n",
       "...                  ...  ..  \n",
       "前端开发          彩讯科技股份有限公司   9  \n",
       "前端开发                桑达实业   9  \n",
       "前端开发                  亨通   9  \n",
       "前端开发        北京南邮信息技术有限公司   9  \n",
       "前端开发          彩讯科技股份有限公司   9  \n",
       "\n",
       "[400 rows x 8 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Front_End = df_all[['关键词','职称','学历','经验','薪水','链接','公司地点','公司名称','页数']].set_index(\"关键词\").loc['前端开发']\n",
    "df_Front_End.to_excel(\"影视文化_前端开发.xlsx\",\\\n",
    "                sheet_name=\"影视文化_前端开发\")\n",
    "df_Front_End"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 筛选出广州的工作数据信息"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>关键词</th>\n",
       "      <th>职称</th>\n",
       "      <th>学历</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>链接</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>页数</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>公司地点</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-19k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932130021.shtml</td>\n",
       "      <td>广信通信</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>产品管理</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-19k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928958071.shtml</td>\n",
       "      <td>广信通信</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>数据分析师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>10-15k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1926654193.shtml</td>\n",
       "      <td>亚信科技</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>云平台工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1920032861.shtml</td>\n",
       "      <td>中国联通广东省分公司</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>高级产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1931617357.shtml</td>\n",
       "      <td>联通沃音乐文化有限公司</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>用户运营</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>7-9k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927870601.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>NPS用户体验</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-7k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927516021.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1916647853.shtml</td>\n",
       "      <td>联通通信</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>新媒体内容运营岗</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1916823547.shtml</td>\n",
       "      <td>中国联通广东省分公司</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>知乎产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>7-9k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1916718125.shtml</td>\n",
       "      <td>中国联通广东省分公司</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>行业分析</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>7-13k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1930657607.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>用户研究</td>\n",
       "      <td>维系策划岗</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-14k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1919408355.shtml</td>\n",
       "      <td>中国联通广东省分公司</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计师（外包）</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1929162439.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>UI设计</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1916647853.shtml</td>\n",
       "      <td>联通通信</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-20k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/22256011.shtml</td>\n",
       "      <td>天河国企单位</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>资深前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1926478309.shtml</td>\n",
       "      <td>爱立信中国</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>C#/C++ Windows桌面应用研发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>11-21k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1931769147.shtml</td>\n",
       "      <td>广信通信</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>IOS研发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>11-22k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1931773925.shtml</td>\n",
       "      <td>广信通信</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>Android研发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>12-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1931604245.shtml</td>\n",
       "      <td>广信通信</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>UI设计</td>\n",
       "      <td>资深平面设计师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>12-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932606735.shtml</td>\n",
       "      <td>联通通信</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-19k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932130021.shtml</td>\n",
       "      <td>广信通信</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>AI硬件产品经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928314167.shtml</td>\n",
       "      <td>广州慧睿思通信息科技有限公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>5G业务专家5G产品总监产品经理</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>25-45k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/22503651.shtml</td>\n",
       "      <td>广州某物联网，大数据，企业信息化集成商</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>变电设备管理软件产品总监 （电力行业产品经理业务专家）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>25-45k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/22503633.shtml</td>\n",
       "      <td>广州某物联网，大数据，企业信息化集成商</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>物联网产品总监产品经理业务专家</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>25-45k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/22503591.shtml</td>\n",
       "      <td>广州某物联网，大数据，企业信息化集成商</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>产品销售部总经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>20-30k·15薪</td>\n",
       "      <td>https://www.liepin.com/a/22219019.shtml</td>\n",
       "      <td>某上市公司</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>行业产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>35-50k·15薪</td>\n",
       "      <td>https://www.liepin.com/a/22207327.shtml</td>\n",
       "      <td>某云公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>售前产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>20-30k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932472081.shtml</td>\n",
       "      <td>广东正邦电力通信工程有限公司</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>智慧屏研发产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20-40k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1928867309.shtml</td>\n",
       "      <td>新华三集团</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>产品销售部总经理</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>33-50k·12薪</td>\n",
       "      <td>https://www.liepin.com/a/22492339.shtml</td>\n",
       "      <td>某股份有限公司</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>产品经理</td>\n",
       "      <td>通信产品经理</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>6-10k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1931476277.shtml</td>\n",
       "      <td>京信通信系统(中国)有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>新媒体运营</td>\n",
       "      <td>新媒体运营</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>5-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932477535.shtml</td>\n",
       "      <td>广东择机网络科技有限公司</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>新媒体运营</td>\n",
       "      <td>高级新媒体运营专员+五险一金</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1923535393.shtml</td>\n",
       "      <td>广州浚峰网络技术有限公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>新媒体运营</td>\n",
       "      <td>新媒体运营</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1922835517.shtml</td>\n",
       "      <td>中国联通广东省分公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发高级工程师（广州）</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>18-35k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1932661945.shtml</td>\n",
       "      <td>亚信科技</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>资深前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>面议</td>\n",
       "      <td>https://www.liepin.com/job/1926478309.shtml</td>\n",
       "      <td>爱立信中国</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>15-20k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/22256011.shtml</td>\n",
       "      <td>天河国企单位</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端研发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>11-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932130873.shtml</td>\n",
       "      <td>广信通信</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932856477.shtml</td>\n",
       "      <td>广东正邦电力通信工程有限公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师（Angular）</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-12k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1932464547.shtml</td>\n",
       "      <td>广州凯媒通讯技术有限公司</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>Web前端开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-18k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932853749.shtml</td>\n",
       "      <td>联通通信</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>高级前端研发工程师</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20-30k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/22342811.shtml</td>\n",
       "      <td>某外资企业</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>8-12k·14薪</td>\n",
       "      <td>https://www.liepin.com/job/1932139365.shtml</td>\n",
       "      <td>广州凯媒通讯技术有限公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>13-22k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1931210835.shtml</td>\n",
       "      <td>中国联通广东省分公司</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师（第三方用工）</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>9-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1932390971.shtml</td>\n",
       "      <td>联通沃音乐文化有限公司</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>20-25k·13薪</td>\n",
       "      <td>https://www.liepin.com/a/22528537.shtml</td>\n",
       "      <td>国内知名上市公司</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>WEB前端开发</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>13-23k·13薪</td>\n",
       "      <td>https://www.liepin.com/job/1923872747.shtml</td>\n",
       "      <td>中国联通广东省分公司</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>13-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1930323839.shtml</td>\n",
       "      <td>联通通信</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>web前端开发（云徙）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>8-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1930605569.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师(驻点云米科技）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>6-10k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1930168341.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>web前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>12-20k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927077159.shtml</td>\n",
       "      <td>广州润芯信息技术有限公司</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1925248211.shtml</td>\n",
       "      <td>中国联通广东省分公司</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师（外派驻点）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1928716185.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州</th>\n",
       "      <td>前端开发</td>\n",
       "      <td>前端开发工程师（驻点南航）</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>7-12k·12薪</td>\n",
       "      <td>https://www.liepin.com/job/1927913093.shtml</td>\n",
       "      <td>彩讯科技股份有限公司</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        关键词                           职称     学历     经验          薪水  \\\n",
       "公司地点                                                                 \n",
       "广州     用户研究                         产品经理  本科及以上   1-3年  10-19k·12薪   \n",
       "广州     用户研究                         产品管理  大专及以上   1-3年  10-19k·12薪   \n",
       "广州     用户研究                        数据分析师   统招本科   3-5年  10-15k·13薪   \n",
       "广州     用户研究                       云平台工程师  本科及以上   经验不限          面议   \n",
       "广州     用户研究                       高级产品经理   统招本科   3-5年  20-25k·12薪   \n",
       "广州     用户研究                         用户运营  本科及以上   1-3年    7-9k·12薪   \n",
       "广州     用户研究                      NPS用户体验  本科及以上   1-3年    6-7k·12薪   \n",
       "广州     用户研究                         UI设计  本科及以上   1-3年   8-12k·12薪   \n",
       "广州     用户研究                     新媒体内容运营岗   统招本科   1-3年    6-8k·12薪   \n",
       "广州     用户研究                       知乎产品经理   统招本科   1-3年    7-9k·12薪   \n",
       "广州     用户研究                         行业分析  本科及以上  5-10年   7-13k·12薪   \n",
       "广州     用户研究                        维系策划岗   统招本科   1-3年   8-14k·12薪   \n",
       "广州     UI设计                    UI设计师（外包）  本科及以上   经验不限   8-12k·12薪   \n",
       "广州     UI设计                         UI设计  本科及以上   1-3年   8-12k·12薪   \n",
       "广州     UI设计                      前端开发工程师  本科及以上   3-5年  15-20k·13薪   \n",
       "广州     UI设计                    资深前端开发工程师   统招本科  5-10年          面议   \n",
       "广州     UI设计      C#/C++ Windows桌面应用研发工程师  本科及以上   1-3年  11-21k·12薪   \n",
       "广州     UI设计                     IOS研发工程师  本科及以上   1-3年  11-22k·12薪   \n",
       "广州     UI设计                 Android研发工程师  本科及以上   1-3年  12-20k·12薪   \n",
       "广州     UI设计                      资深平面设计师  本科及以上   1-3年  12-20k·12薪   \n",
       "广州     产品经理                         产品经理  本科及以上   1-3年  10-19k·12薪   \n",
       "广州     产品经理                     AI硬件产品经理  本科及以上  5-10年  15-25k·12薪   \n",
       "广州     产品经理             5G业务专家5G产品总监产品经理  大专及以上   经验不限  25-45k·13薪   \n",
       "广州     产品经理  变电设备管理软件产品总监 （电力行业产品经理业务专家）  大专及以上   经验不限  25-45k·13薪   \n",
       "广州     产品经理              物联网产品总监产品经理业务专家  大专及以上   经验不限  25-45k·13薪   \n",
       "广州     产品经理                     产品销售部总经理  本科及以上  5-10年  20-30k·15薪   \n",
       "广州     产品经理                       行业产品经理   统招本科  5-10年  35-50k·15薪   \n",
       "广州     产品经理                       售前产品经理   统招本科  5-10年  20-30k·12薪   \n",
       "广州     产品经理                    智慧屏研发产品经理   统招本科   3-5年  20-40k·14薪   \n",
       "广州     产品经理                     产品销售部总经理  本科及以上  5-10年  33-50k·12薪   \n",
       "广州     产品经理                       通信产品经理   统招本科   3-5年   6-10k·14薪   \n",
       "广州    新媒体运营                        新媒体运营  本科及以上   经验不限    5-8k·12薪   \n",
       "广州    新媒体运营               高级新媒体运营专员+五险一金  大专及以上   1-3年    6-8k·12薪   \n",
       "广州    新媒体运营                        新媒体运营  本科及以上   1-3年  10-15k·12薪   \n",
       "广州     前端开发                前端开发高级工程师（广州）   统招本科   3-5年  18-35k·13薪   \n",
       "广州     前端开发                    资深前端开发工程师   统招本科  5-10年          面议   \n",
       "广州     前端开发                      前端开发工程师  本科及以上   3-5年  15-20k·13薪   \n",
       "广州     前端开发                      前端研发工程师  本科及以上   1-3年  11-20k·12薪   \n",
       "广州     前端开发                      前端开发工程师  大专及以上   3-5年   8-12k·12薪   \n",
       "广州     前端开发             前端开发工程师（Angular）   统招本科   1-3年   8-12k·14薪   \n",
       "广州     前端开发                   Web前端开发工程师  本科及以上   1-3年  10-18k·12薪   \n",
       "广州     前端开发                    高级前端研发工程师   学历不限   3-5年  20-30k·13薪   \n",
       "广州     前端开发                      前端开发工程师   统招本科   1-3年   8-12k·14薪   \n",
       "广州     前端开发                      前端开发工程师   统招本科   经验不限  13-22k·12薪   \n",
       "广州     前端开发               前端开发工程师（第三方用工）  本科及以上   3-5年   9-12k·12薪   \n",
       "广州     前端开发                      前端开发工程师   学历不限  5-10年  20-25k·13薪   \n",
       "广州     前端开发                      WEB前端开发   统招本科   1-3年  13-23k·13薪   \n",
       "广州     前端开发                      前端开发工程师  本科及以上   1-3年  13-15k·12薪   \n",
       "广州     前端开发                  web前端开发（云徙）  大专及以上   3-5年   8-15k·12薪   \n",
       "广州     前端开发              前端开发工程师(驻点云米科技）  大专及以上  5-10年   6-10k·12薪   \n",
       "广州     前端开发                   web前端开发工程师   统招本科   1-3年  12-20k·12薪   \n",
       "广州     前端开发                      前端开发工程师   统招本科   1-3年  10-15k·12薪   \n",
       "广州     前端开发                前端开发工程师（外派驻点）  大专及以上   经验不限  10-15k·12薪   \n",
       "广州     前端开发                前端开发工程师（驻点南航）  大专及以上   经验不限   7-12k·12薪   \n",
       "\n",
       "                                               链接                 公司名称  页数  \n",
       "公司地点                                                                        \n",
       "广州    https://www.liepin.com/job/1932130021.shtml                 广信通信   1  \n",
       "广州    https://www.liepin.com/job/1928958071.shtml                 广信通信   1  \n",
       "广州    https://www.liepin.com/job/1926654193.shtml                 亚信科技   3  \n",
       "广州    https://www.liepin.com/job/1920032861.shtml           中国联通广东省分公司   4  \n",
       "广州    https://www.liepin.com/job/1931617357.shtml          联通沃音乐文化有限公司   5  \n",
       "广州    https://www.liepin.com/job/1927870601.shtml           彩讯科技股份有限公司   6  \n",
       "广州    https://www.liepin.com/job/1927516021.shtml           彩讯科技股份有限公司   6  \n",
       "广州    https://www.liepin.com/job/1916647853.shtml                 联通通信   6  \n",
       "广州    https://www.liepin.com/job/1916823547.shtml           中国联通广东省分公司   6  \n",
       "广州    https://www.liepin.com/job/1916718125.shtml           中国联通广东省分公司   6  \n",
       "广州    https://www.liepin.com/job/1930657607.shtml           彩讯科技股份有限公司   7  \n",
       "广州    https://www.liepin.com/job/1919408355.shtml           中国联通广东省分公司   8  \n",
       "广州    https://www.liepin.com/job/1929162439.shtml           彩讯科技股份有限公司   2  \n",
       "广州    https://www.liepin.com/job/1916647853.shtml                 联通通信   2  \n",
       "广州        https://www.liepin.com/a/22256011.shtml               天河国企单位   4  \n",
       "广州    https://www.liepin.com/job/1926478309.shtml                爱立信中国   4  \n",
       "广州    https://www.liepin.com/job/1931769147.shtml                 广信通信   4  \n",
       "广州    https://www.liepin.com/job/1931773925.shtml                 广信通信   5  \n",
       "广州    https://www.liepin.com/job/1931604245.shtml                 广信通信   5  \n",
       "广州    https://www.liepin.com/job/1932606735.shtml                 联通通信   8  \n",
       "广州    https://www.liepin.com/job/1932130021.shtml                 广信通信   0  \n",
       "广州    https://www.liepin.com/job/1928314167.shtml       广州慧睿思通信息科技有限公司   1  \n",
       "广州        https://www.liepin.com/a/22503651.shtml  广州某物联网，大数据，企业信息化集成商   2  \n",
       "广州        https://www.liepin.com/a/22503633.shtml  广州某物联网，大数据，企业信息化集成商   2  \n",
       "广州        https://www.liepin.com/a/22503591.shtml  广州某物联网，大数据，企业信息化集成商   2  \n",
       "广州        https://www.liepin.com/a/22219019.shtml                某上市公司   2  \n",
       "广州        https://www.liepin.com/a/22207327.shtml                 某云公司   3  \n",
       "广州    https://www.liepin.com/job/1932472081.shtml       广东正邦电力通信工程有限公司   5  \n",
       "广州    https://www.liepin.com/job/1928867309.shtml                新华三集团   5  \n",
       "广州        https://www.liepin.com/a/22492339.shtml              某股份有限公司   7  \n",
       "广州    https://www.liepin.com/job/1931476277.shtml       京信通信系统(中国)有限公司   9  \n",
       "广州    https://www.liepin.com/job/1932477535.shtml         广东择机网络科技有限公司   0  \n",
       "广州    https://www.liepin.com/job/1923535393.shtml         广州浚峰网络技术有限公司   1  \n",
       "广州    https://www.liepin.com/job/1922835517.shtml           中国联通广东省分公司   1  \n",
       "广州    https://www.liepin.com/job/1932661945.shtml                 亚信科技   0  \n",
       "广州    https://www.liepin.com/job/1926478309.shtml                爱立信中国   0  \n",
       "广州        https://www.liepin.com/a/22256011.shtml               天河国企单位   0  \n",
       "广州    https://www.liepin.com/job/1932130873.shtml                 广信通信   1  \n",
       "广州    https://www.liepin.com/job/1932856477.shtml       广东正邦电力通信工程有限公司   1  \n",
       "广州    https://www.liepin.com/job/1932464547.shtml         广州凯媒通讯技术有限公司   1  \n",
       "广州    https://www.liepin.com/job/1932853749.shtml                 联通通信   1  \n",
       "广州        https://www.liepin.com/a/22342811.shtml                某外资企业   3  \n",
       "广州    https://www.liepin.com/job/1932139365.shtml         广州凯媒通讯技术有限公司   3  \n",
       "广州    https://www.liepin.com/job/1931210835.shtml           中国联通广东省分公司   3  \n",
       "广州    https://www.liepin.com/job/1932390971.shtml          联通沃音乐文化有限公司   4  \n",
       "广州        https://www.liepin.com/a/22528537.shtml             国内知名上市公司   4  \n",
       "广州    https://www.liepin.com/job/1923872747.shtml           中国联通广东省分公司   5  \n",
       "广州    https://www.liepin.com/job/1930323839.shtml                 联通通信   6  \n",
       "广州    https://www.liepin.com/job/1930605569.shtml           彩讯科技股份有限公司   7  \n",
       "广州    https://www.liepin.com/job/1930168341.shtml           彩讯科技股份有限公司   7  \n",
       "广州    https://www.liepin.com/job/1927077159.shtml         广州润芯信息技术有限公司   8  \n",
       "广州    https://www.liepin.com/job/1925248211.shtml           中国联通广东省分公司   8  \n",
       "广州    https://www.liepin.com/job/1928716185.shtml           彩讯科技股份有限公司   9  \n",
       "广州    https://www.liepin.com/job/1927913093.shtml           彩讯科技股份有限公司   9  "
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Guangzhou = df_all_1.set_index(\"公司地点\").loc['广州']\n",
    "df_Guangzhou.to_excel(\"广州影视文化企业_用户研究_UI设计_产品经理_新媒体运营_前端开发.xlsx\",\\\n",
    "              sheet_name=\"影视文化_广州\")\n",
    "df_Guangzhou"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# END"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
